﻿Create PROCEDURE [dbo].[proc_Employee_Allowance_CompanyId_GetList]
	(
		@EAId uniqueidentifier
	)
AS
	Select 
		wsc.Id,
		wsc.EAId,
		wsc.CompanyId,
		(Select C.CompanyName From Company C Where C.Id=wsc.CompanyId) as CompanyName 
	From Employee_Allowance_Company wsc Where wsc.EAId=@EAId
	RETURN
